package com.erp.erp_mask.mapper;

import com.erp.erp_mask.pojo.TBom;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author yang
* @description 针对表【t_bom】的数据库操作Mapper
* @createDate 2024-05-17 16:36:56
* @Entity com.erp.erp_mask.pojo.TBom
*/
public interface TBomMapper extends BaseMapper<TBom> {
    List<TBom> searchlist(Integer level);
    //新增父级节点
    void faddlist(TBom tBom);
    @Select("select * from t_bom where bom_id=#{level}")
    List<TBom> selectflist(Integer level);
    void edit(TBom tBom);
    @Select("select count(*) from t_bom where bom_level in (select bom_level from t_bom where bom_level=#{id});")
    Integer delsearch(Integer id);
}




